The Hochschulen Table

library(studentenstatistikNRW)
library(tibble)

hochschulen
#> # A tibble: 540 × 46
#>    Hochschulart_Hochschu…¹ Hochschule_Signatur Hochschule Hochschule_EN `Hs-Nr.`
#>    <chr>                   <chr>               <chr>      <chr>            <dbl>
#>  1 10725                   001                 Universit… University o…      142
#>  2 60515                   002                 APOLLON H… University o…      361
#>  3 60265                   003                 Hochschul… Macromedia U…      366
#>  4 61074                   004                 Fachhochs… FH Diakonie,…      375
#>  5 60129                   006                 Hochschul… German Unive…      457
#>  6 11034                   008                 Universit… University o…       71
#>  7 11060                   012                 Universit… University o…      215
#>  8 11065                   013                 Universit… University o…      245
#>  9 11070                   014                 Universit… University o…      279
#> 10 11040                   015                 Fernunive… FernUniversi…      100
#> # ℹ 530 more rows
#> # ℹ abbreviated name: ¹​Hochschulart_Hochschule_Signatur
#> # ℹ 41 more variables: Wiki_ID_DE <dbl>, Wikidata_ID <chr>, Wiki_ID_EN <dbl>,
#> #   Wiki_Key_EN <chr>, Wiki_Logo_DE <chr>, Wiki_Logo_DE_File <chr>,
#> #   Wiki_Logo_DE_Description <chr>, Wiki_Logo_DE_URL <chr>,
#> #   Wiki_Logo_DE_Thumbnail_URL <chr>, ROR_ID <chr>, Multirank <chr>, Ort <chr>,
#> #   Domain_Hochschule_HRK <chr>, CHE_DAAD_University_ID <dbl>, …

Interactive HTML Table created with gt Package

Institutions of Higher Education in Germany
Sub

As of March 13, 2024, the Federal Statistical Office of Germany (Destatis) lists a total of 427 institutions of higher education in the country. In this vignette, we will use this official data source as basis and go through considerable efforts to complement this data with other sources. In particular:

  • We will download all key tables for the student statistics (table series 372) provided by the Federal Statistical Agency (Destatis) on its data collection portal (Erhebungsportal). There are four key tables / csv files containing data on institutions of higher education in Germany: 1.) Hochschule, 2.) HochschulStandort, 3.) HochschuleErsteinschreibung, and 4.) HochschulFachbereich, each with slight differences in how and where institutions are counted (e.g. when a university has subsidiary campuses in other cities and German states),

  • we will then match the Destatis data with the list of all institutions of higher education in Germany provided by the German Rector’s Conference (HRK). The Federal Statistical Agency data together with the HRK list are the “most authoritative German numbers” that exist.

  • As described in vignette("ror"), we use the global Research Organization Registry (ROR) REST API to retrieve additional data and identifiers which are then matched to the existing data.

This is the exhaustive list of additional data sources that are linked up:

  • links to the German and English Wikipedia article for each institution,

  • links to the Wikidata entry for each institution and a separate link to each institution’s German logo, if available,

  • the link to each institution on studieren.de,

  • the link to the CHE University Ranking for each institution hosted by the German Academic Exchange Service in English,

  • the link for each institution’s multirank for 2022-2023,


fs::file_delete(
  unique(logo_url_written[!is.na(logo_url_written)])
)